﻿CREATE TABLE [dbo].[AuditLog] (
    [AuditLogID]      UNIQUEIDENTIFIER NOT NULL,
    [ActionType]    VARCHAR(50) NOT NULL,
    [MessageID]       UNIQUEIDENTIFIER NOT NULL,
    [NativeMessageID] VARCHAR (38)     NULL,
    [ContentType]     VARCHAR (50)     NULL,
    [MessageName]     VARCHAR (50)     NULL,
    [FaultID]         UNIQUEIDENTIFIER NULL,
    [NativeFaultID]   VARCHAR (38)     NULL,
    [Application]     VARCHAR (256)    NULL,
    [ServiceName]     VARCHAR (256)    NULL,
    [ResubmitURL]     VARCHAR (512)    NULL,
    [ResubmitCode]    VARCHAR (3)      NULL,
    [ResubmitMessage] VARCHAR (255)     NULL,
    [AuditDate]       DATETIME         NOT NULL,
    [AuditUserName]   VARCHAR (256)    NOT NULL
);

